2013-03-22 - 5910.200 - Rel Notes - Contracts - Release 008 #BIReleases2013
Release Notes:
5910.200 - Contracts - OSA910
Admin Info
Purpose
|
Including Contract Information in OSA910 report
|
Release No
|
008
|
Submitted
|
03-22-2013
|
Submitted by
|
Mallareddy D
|
Source/Destination Systems
|
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Mallareddy D
|
Object(s) Tested By
|
Praveen Guntuka
|
Report Name
OSA910 - Open Orders by Sales Org, SBU, Sport, License, Team and Style
BEx Query
ZMP_OPASA_Q031
NEC Crystal Reports Standards Check
1. OSA910 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. OSA910 NEC CR checklist has been sent to NEC and also attached here for reference.
OSA910 NEC CR Standard Check List.xlsx
Dynamic Group 1:
Test Conducted
Dynamic Grouping Parameter(1) and Group Name: SBU > Sport > License > Team > Style
Summary Level Check
Test Conducted
Group: Sales Orgs - 5th & Ocean Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
74,007
|
74,007
|
Pass
|
2
|
Sales Org Currency
|
7,977,572
|
7,977,571.74
|
Pass
|
3
|
Corporate Currency
|
1,028,647
|
1,028,647.36
|
Pass
|
Group: Sales Orgs - EMEA Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
1,805,357
|
1,805,357
|
Pass
|
2
|
Sales Org Currency
|
15,670,379
|
15,670,381.86
|
Fail
|
3
|
Corporate Currency
|
23,864,479
|
23,864,436.67
|
Fail
|
Note: For EMEA Sales, Sales Org, Sales Org Currency and Corporate Currency values are not matching with BEx Query values. The difference is $2 and $43 respectively.
Second Level Check
Test Conducted
Group: Australia Sales > NEW ERA BRANDED
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
2,314
|
2,314
|
Pass
|
2
|
Sales Org Currency
|
45,377
|
45,376.52
|
Pass
|
3
|
Corporate Currency
|
46,497
|
46,497.32
|
Pass
|
Third Level Check
Test Conducted
Group: EMEA > KIDS > BASKET BALL
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
1,356
|
1,356
|
Pass
|
2
|
Sales Org Currency
|
12,554
|
12,554.61
|
Pass
|
3
|
Corporate Currency
|
19,119
|
19,119.15
|
Pass
|
Fourth Level Check
Test Conducted
Group: Latin America > ENTERTAINMENT > ANIMATED CHARACTER > DISNEY
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
456
|
456
|
Pass
|
2
|
Sales Org Currency
|
3,566
|
3,566.40
|
Pass
|
3
|
Corporate Currency
|
3,566
|
3,566.40
|
Pass
|
Fifth Level Check
Test Conducted
Group: NEC Korea Sales > FANGEAR > BASEBALL > MLB PROPERTIES > CHICAGO WHITE SOX
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
78
|
78
|
Pass
|
2
|
Sales Org Currency
|
1,067,196
|
1,067,196.00
|
Pass
|
3
|
Corporate Currency
|
960
|
960.48
|
Pass
|
Sixth Level Check
Test Conducted
Group: 5th & Ocean > VICTORIA SECRET > COLLEGE > COLLEGIATE LICENSING > ARIZONA WILDCATS > TANK
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
408
|
408
|
Pass
|
2
|
Sales Org Currency
|
3,762
|
3,761.76
|
Pass
|
3
|
Corporate Currency
|
3,762
|
3,761.56
|
Pass
|
Group: 5th & Ocean > VICTORIA SECRET > COLLEGE > COLLEGIATE LICENSING > ARIZONA WILDCATS > TANK
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
209,249
|
209,249
|
Pass
|
2
|
Sales Org Currency
|
2,331,782
|
2,331,778.16
|
Pass
|
3
|
Corporate Currency
|
3,551,092
|
3,551,081.29
|
Pass
|
Note: For EMEA Sales, Sales Org, Sales Org Currency and Corporate Currency values are not matching with BEx Query values. The difference is $4 and $43 respectively.
Dynamic Group 2:
Test Conducted
Dynamic Grouping Parameter(2) and Group Name: Sport > License > Team > Style
Summary Level Check
Test Conducted
Group: Sales Orgs - United States Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
10,706,855
|
10,706,855
|
Pass
|
2
|
Sales Org Currency
|
110,947,290
|
110,947,290.20
|
Pass
|
3
|
Corporate Currency
|
110,947,290
|
110,947,290.20
|
Pass
|
Second Level Check
Test Conducted
Group: Mexico Sales > FOOTBALL
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
138,802
|
138,802
|
Pass
|
2
|
Sales Org Currency
|
27,789,169
|
27,789,169.15
|
Pass
|
3
|
Corporate Currency
|
2,178,670
|
2,178,670.86
|
Pass
|
Third Level Check
Test Conducted
Group: German Sales > BASKETBALL > NBA PROPERTIES
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
66
|
66
|
Pass
|
2
|
Sales Org Currency
|
1,023
|
1,023.00
|
Pass
|
3
|
Corporate Currency
|
1,354
|
1,353.63
|
Pass
|
Fourth Level Check
Test Conducted
Group: Canada Sales > GOLF > NON LICENSED > NONE
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
288
|
288
|
Pass
|
2
|
Sales Org Currency
|
3,528
|
3,528.00
|
Pass
|
3
|
Corporate Currency
|
3,465
|
3,464.85
|
Pass
|
Fifth Level Check
Test Conducted
Group: APAC sales > HOCKEY > NHL PROPERTIES > LOS ANGELES KINGS > 5950
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
31
|
31
|
Pass
|
2
|
Sales Org Currency
|
4,355
|
4,354.66
|
Pass
|
3
|
Corporate Currency
|
562
|
561.50
|
Pass
|
Dynamic Group 3:
Test Conducted
Dynamic Grouping Parameter(3) and Group Name: Sport > License > Year > Team > Style
Summary Level Check
Test Conducted
Group: Sales Orgs - NEC Korea Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
24,281
|
24,281
|
Pass
|
2
|
Sales Org Currency
|
475,569,687
|
475,569,687.00
|
Pass
|
3
|
Corporate Currency
|
428,013
|
428,012.72
|
Pass
|
Second Level Check
Test Conducted
Group: Latin America Sales > BASKETBALL
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
48
|
48
|
Pass
|
2
|
Sales Org Currency
|
586
|
585.60
|
Pass
|
3
|
Corporate Currency
|
586
|
585.60
|
Pass
|
Third Level Check
Test Conducted
Group: EMEA > SOCCER >NON LICENSED
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
8,817
|
8,817
|
Pass
|
2
|
Sales Org Currency
|
43,671
|
43,670.88
|
Pass
|
3
|
Corporate Currency
|
66,505
|
66,504.51
|
Pass
|
Fourth Level Check
Test Conducted
Group: EMEA Sales > Accessories > Aldo Goldoni > 1011195 AMANITO SMART SHOP
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
11
|
11
|
Pass
|
2
|
Sales Org Currency
|
165
|
165.00
|
Pass
|
3
|
Corporate Currency
|
169
|
169.08
|
Pass
|
Fifth Level Check
Test Conducted
Group: 5th & Ocean Sales > RACING > NON LICENSED > 2013 >NONE
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
694
|
694
|
Pass
|
2
|
Sales Org Currency
|
4,806
|
4,805.75
|
Pass
|
3
|
Corporate Currency
|
4,806
|
4,805.75
|
Pass
|
Sixth Level Check
Test Conducted
Group: Mexico Sales > FOOTBALL > NFL PROPERTIES > 2013 > DALLAS COWBOYS >950
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
528
|
528
|
Pass
|
2
|
Sales Org Currency
|
108,054
|
108,054.42
|
Pass
|
3
|
Corporate Currency
|
8,471
|
8,471.45
|
Pass
|
Dynamic Group 4:
Test Conducted
Dynamic Grouping Parameter(4) and Group Name: License > Customer
Summary Level Check
Test Conducted
Group: Sales Orgs - APAC Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
74,007
|
74,007
|
Pass
|
2
|
Sales Org Currency
|
7,977,572
|
7,977,571.74
|
Pass
|
3
|
Corporate Currency
|
1,028,647
|
1,028,647.36
|
Pass
|
Second Level Check
Test Conducted
Group: Canada Sales > DISNEY
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
93
|
93
|
Pass
|
2
|
Sales Org Currency
|
1,251
|
1,250.88
|
Pass
|
3
|
Corporate Currency
|
1,228
|
1,228.49
|
Pass
|
Third Level Check
Test Conducted
Group: German Sales > NFL PROPERTIES > GALERIA KAUFHOF GMBH – 1004350
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
58
|
58
|
Pass
|
2
|
Sales Org Currency
|
840
|
840.20
|
Pass
|
3
|
Corporate Currency
|
1,112
|
1,111.75
|
Pass
|
Reference Document (Specification)
2013-03-15 - 5910.200 - Spec - Contract Reports